﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Configuration;

namespace WEB.Data
{
    public class DBSQL
    {
        private String connString = "";
        private SqlConnection conn = new SqlConnection();
        private SqlCommand comm = new SqlCommand();

        public DBSQL()
        {
            connString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
            this.init();
        }

        public void init()
        {
            this.conn.ConnectionString = this.connString;
            this.conn.Open();
        }

        public int ExecuteNonQuery(String sql,params SqlParameter[] commandParas)
        {
            int val = SqlHelper.ExecuteNonQuery(this.conn, System.Data.CommandType.Text, sql, commandParas);
            return 0;
        }

    }
}